價格:免費
更新日期:2018-10-02
檔案大小:5.1M
目前版本:1.1.0
版本需求:Android 4.4 以上版本
官方網站:http://www.test4u.eu
Email:info@test4u.eu
聯絡地址:Pindou 6 & Karatza 55135 Kalamaria Thessaloniki Greece
This provides the users with the opportunity to get an initial picture about various MS-Excel Functions.
You will find many questions, accompanied by their video-solutions about Microsoft Excel functions. Watching the videosolutions will allow you to get a good idea concerning the skills that you have and assess your level.
The videosolutions are classified into categories so as to let you focus wherever you believe there is some skill shortage. This is how there is almost no time wasted in repeating the parts that you are already familiar with.
The full version is known as TEST4U and constitutes a complete self-study, interactive guide, available since 2003, with more than 700.000 satisfied users.
The candidates can access the full training package in order to be able to respond successfully to Certification Examinations not only for MS-Excel, but also for MS-Word, MS-PowerPoint, MS-Access, Internet & Windows for the Basic or the Advanced level of Microsoft-Certiport Exams, ECDL-ICDL Exams, e.tc.
Functions included:
Error Solving
VALUE, ISERROR, IFERROR, ISFORMULA, ISTEXT, ISBLANK, ISERR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, FORMULATEXT
Text functions
FIND, EXACT, SEARCH, REPLACE, SUBSTITUTE, TEXT, CHAR, T(), REPT, PROPER, UPPER, LOWER, CONCATENATE, LEFT, MID, TRIM, RIGHT
Mathematical Functions
ABS, CEILING, EXP, FLOOR, INT, LN, MOD, PI, ROUND, PI,MROUND, PRODUCT, RAND, RANDBETWEEN, ROUND, ROUNDDOWN, ROUNDUP, SQRT, ABS, SUBTOTAL, SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ
Logical functions
AND, IF, OR, IF, NOT
Date and Time functions
DATE, DATEDIF, TODAY, HIDDEN, DATEVALUE, DAY, DAY, MONTH, YEAR, DAYS, DATEDIF, NETWORKDAYS, EDATE, EOMONTH, NETWORKDAYS, NOW, TIMEVALUE, TODAY, WEEKDAY, WORKDAY, WORKDAY.INTL
Lookup functions
CELL, CHOOSE, HLOOKUP, INDEX, INDEX, MATCH,, INDIRECT, ISREF, INDIRECT, LOOKUP, MATCH, SUM, OFFSET, VLOOKUP
Financial Functions
ACCRINT, ACCRINTM, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMPRINC,CUMIPMT, DB, DDB, DISC, DOLLARDE, DOLLARFR, DURATION, EOQ, FV, INTRATE, IPMT, IRR, LOGNORM.DIST,LOGNORM.INV, MDURATION, MIRR, NPER, NPV, PMT, PPMT, PRICE, PRICEDISC, PRICEMAT, PV, RAND, NORM.INV, RATE, RECEIVED, SLN, SLOPE,INTERCEPT, STDEV.S, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, VDB, WEIBULL.DIST, XIRR, XNPV, YIELD, YIELDDISC, YIELDMAT
Statistical functions
AVERAGE, AVERAGEIF, AVERAGEIFS, BINOM.DIST, BINOM.INV, BINOM.INV, RAND, CORREL, CORRELATION, COEFFICIENT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, COVAR, COVARIANCE, COVARIANCE.S, COVARIANCE.P, DAVERAGE, DCOUNT, DMIN, DMAX, DSUM, EXPON.DIST, HYPGEOM.DIST, LARGE, MEDIAN, MODE, MIN, NEGBINOM.DIST, NORM.DIST, NORM.INV, PERCENTILE, PERCENTILE.EXC, PERCENTILE.INC, POISSON.DIST, QUARTILE, QUARTILE.INC, QUARTILE.EXC, RANK, SMALL, STDEV, STDEVP,STDEV.P, STDEV.S, SUM, MAX, COUNT, TREND, TRIMMEAN, GEOMEAN, VAR, VAR.S, VAR.P, VARP
Array Formulas
FREQUENCY, SUM,LARGE, TRANSPOSE
Cube Functions
CUBEKPIMEMBER, CUBEVALUE, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBESETCOUNT, CUBEVALUE